Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

Table Join
1) A SELECT statement that joins the Bankers and Billings tables
2) A self join is really an inner or outer join on the same table
3) A self-join that returns Bankers from cities in common with other Bankers
4) An inner join with correlation names that make the query more difficult to read
5) An one-to-many relation
6) Cross Join with itself
7) Employees and Their Managers
8) Enables the changes in the Classes table to propagate to the ClassGrades table
9) Forcing the Order of Join Processing
10) Full Outer Joins
11) Implementing Many-to-Many Relationships with Foreign Keys
12) Inner join two table with column in common
13) Inner join with where clause
14) INNER MERGE JOIN
15) It is the Cartesian product of all the rows from all tables participating in the SELECT statement
16) Join tables with two columns
17) Joining Tables in the FROM Clause (ANSI standard)
18) Joining Tables in the WHERE Clause (not ANSI standard)
19) Joining three tables
20) Joins and Subqueries
21) Left and Right Outer Joins
22) LEFT OUTER JOIN with condition
23) Matching Couples Using a Cross Join; Couples with Different Genders
24) Once you decide to alias a table, you must use that alias in every part of the query
25) Select distinct value from inner join
26) Selecting all titles and associated sales using a Right Outer Join
27) Selecting authors and titles using only joins
28) Selecting titles that have not been sold
29) Set join condition in ON clause
30) Simple OUTER JOIN
31) SQL Server 2005 join types fall into three categories
32) SQL-92 Cross Join Syntax
33) SQL-92 Three-Way Inner Joins
34) Table Aliasing
35) The explicit syntax for an inner join
36) The query restated without a subquery
37) The query uses non-ANSI outer join operators (= or =)
38) The result of the previous join is then joined to another table
39) The syntax for an inner join that uses correlation names
40) Update a many-to-many relation (student, class, classgrade)
41) Using APPLY to Invoke a Table-Valued Function for Each Row
42) Using the GROUP BY Clause
43) Works with the qualified operator